Deutsche Bank

About Deutsche Bank/Role:

The 8th or 9th company to visit the campus. It is a German investment bank. Offices present in Pune and Bangalore. Job role offered is Graduate Analyst. The stack you are expected to work on would be Java (Springboot). Knowledge of GCP would help.

CTC offered: 19.625 lpa (joining bonus 3 lakh included)

In hand salary: 15 lpa

1. Aptitude Round: 

3 coding questions were asked. One on N-Queen problem (backtracking). The rest of the two were medium level questions and fairly difficult compared to other company's aptitude rounds. 

2. Technical Round 1:

We were informed in advance the name of the interviewers. It is a good practice to research the interviewer's skills on LinkedIn in such a case. I was asked the following questions:

1. Introduction
2. Where do you see yourself in 5 years?
3. Explain normal forms in DBMS
4. How do you implement 2nd NF in a database?
5. What is Atomicity? Is it same as Consistency?
6. How do you achieve Atomicity in a database?
7. Explain ACID principles
8. What is a lock in DBMS?
9. How are locks implemented?
10. There was a question about a specific lock type and I was unable to answer it so he shifted to SQL.
11. Given an employee table, with employee name, employee id employee salary, another department table with department id and employee id, create a new table which provides the highest salaries of employees department wise.
12. Write a code for 3d matrix multiplication 

3. Technical Round 2:

Almost one third of the people got selected for the next round. The next interviewer went through the resume. The following questions were asked:

1. Introduction
2. Which language are you proficient in? I answered Java. The interviewer was used to C++. 
3. I was asked to write the code for a very simple problem.
4. A sorting question: Given a list of numbers, which would be the fastest way to sort it. I answered merge sort. He asked me to take a look at the numbers closely. The list was arranged in a way that you would not require to sort it through any sorting technique. A few more list examples were shown and the approach to sort was checked here
5. Puzzle: If there is a bus of 100 seats each numbered 1-100 and passengers each numbered 1-100, if all the passengers entered in a random order inside the bus and sat on any seat number, what is the probability that the 100th passanger gets the seat same as his number? Ans: 50%
6. The first project in my Resume used AWS. Related questions were: Why have you used AWS in the project? Why are lambda functions necessary in your project? What is the alternative for EC2 in GCP?
7. What have you studied about GCP? Name a few services and their uses.                 There were a few more questions which I am unable to recall. Interviewer was very friendly and supportive. 

4. Profit Round:

This round was a check the communication skills as well as the capability to handle social scenarios. Similar to an HR round.

5. HR Round:

The usual questions about strength, weaknesses, why Deutsche Bank, goals, etc.

Tips:

1. Read well about the job description and company background before applying to any company.
2. DBMS, SQL were majorly asked
3. Have a good project as the first one in your resume
4. Read a few GFG puzzles
5. A little knowledge of GCP can be very helpful.
6. Confidence > Correctness of the answer.

So Deutsche Bank Contacted our College in month of July.
There were total 5 rounds including 1 aptitude and 4 interview rounds.
The aptitude round was conducted online on maybe 22 July.

1)Aptitude Round:
It's consisted of 3 Coding questions of medium to hard difficulty in a time of 1.5 hrs.

1st questions was on array of medium difficulty.
2nd question was on string which was slightly difficult among all the coding questions.
The  output was expected to be yes or no.Even if you do not solve the question thoroughly Be sure to do the question partially as many students were selected by solving partially.
3rd question was based on bfs..a typical leetcode questions...similar to dijkstra.

For the preparation of Coding round i will recommend you to solve the question of leetcode of medium and hard level difficulty.
So after 1 week 30 students were shortlisted.
The interviews were held after 1 week of coding round so it gives a Plenty of time to prepare for interviews.

1st Interview Round.
So In the first Round he ask me rate in Cpp out of 10...then he ask me basic question of CPP like constructor destructor,deep copy shallow copy, exception handling etc.Then he ask me one of my project..then lastly one puzzle..the round lasts about 40 min.

2nd Interview Round

 In the second Round the interviewer ask me About my Project Tech Stack and said to explain my role in my project...
Then he ask whether u know SQL...as my all projects were based on nosql I just said I know the basics ..then he asked the basics SQL..not queries just intersection union and joins of SQL...Then he asked me One n Ary Tree question to find a particular node and return the path from root to that particular node.. then he ask me to do a run time polymorphism and lastly he asked me a puzzle.
 

3rd and 4th Round

 In the third round they mostly give you a situation and see how you behave it...He asked my open elective and why u choose them..And some other general Discussion...
In the Fourth Round there were just question about my family background and other... discussion...
Mostly Deutsche Bank focuses on SQL...the people whose projects have MySQL Database must prepared SQL.. throughly

Deutsche Bank is a German multinational investment bank and financial services company. Generally, they start oncampus hiring in month of July. They offered the job role of Graduate Analyst. Their process of hiring includes 1 aptitude (coding) test round and 4 interview rounds.
 

Aptitude Test :
In this round, there were 3 coding questions of medium to hard difficulty. 2 medium and 1 hard question. These questions were based on array, string and graph. 

The time given to solve these three coding questions was 1 hour 30 minutes.
 

4 Interview rounds :

Technical Round 1 :
The very first question interviewer asked was my introduction. Next question was where do you see yourself after 5 years. Then as I mentioned about my internship in resume, he started asking questions about my internship. Then he moved towards technical questions on DSA, OOPs and DBMS.
Questions asked during this interview:
1. Write a code to reverse a string: 
input - Hello World 
output - World Hello
Interviewer asked me to write this code within 5-6 min. And after 5 min he asked me to stop writing. Fortunately, I was able to complete my code within time.
2. All OOPs concept were asked with real time examples. 
3. Deep dive into DBMS. 
- Normalise given table till 3rd Normal form.
- How will you achieve consistency in database?
- Deep discussion about locking protocols and ACID Properties.
- How to find nth highest salary?
- Lot of SQL queries were asked to frame on joins, aggregate functions and subqueries. For this, they will give you input tables and also will tell you how the output table look like.
This round lasts about 40 min.

Technical Round 2 :
Second Technical round was a deeper discussion about the projects mentioned in my resume.
I mentioned my top 3 projects in resume. Interviewer asked me to explain any of the two projects. So, I explained 1st project. He asked me the following question regarding the 1st project:
1. My contribution in the project.
2. Tech stack and basic questions on mentioned tech stack.
After these questions, I explained 2nd project which we have built during hackathon in which my team was runner up. I shared my screen and gave live demonstration of that project. The interviewer then asked me about my role in this project. He told me to explain the features of this project. He was quite clear with my project idea and implementation because of live demonstration.
Then after project discussion, he asked me question on sorting techniques and their complexities and to compare them and tell which sorting technique is best. He asked me whether I know about JDBC. As I answered Yes, he asked me a question - how to do database connection in Java (basically, a JDBC connection code)?
This round lasts for 35 min. 

Professional Fitment Round :
This round was like managerial round. In this round, they will check your communication skills and will ask about your achievements and hobbies. If you mentioned any club related activity or achievement in your resume, they will also like to know about it. Also, they will give you some scenarios and will ask how will you behave in those situations. They will ask you about your area of interest to work (like which technology you are interested to work in). Also during my interview, interviewer asked me whether I have some finance related knowledge. As I answered Yes, he asked me some financial questions like what I know about mutual funds and investments. 
This round lasts about 25 min.

HR Round 
General discussion about you and your family background. HR will ask questions like which location(city) you will prefer to work, why you want to join deutsche bank and whether you know any product of the company. 

It was just 10-12 mins conversation with HR.

Tips:
1. Be confident throughout the interview.
2. Think aloud when interviewer ask you to write a code.
3. DBMS and SQL are much more important. Study it thoroughly.
4. Read about the company's background and their products a little more.

Deutsche Bank is a Global Investment Bank. The role which they offer is Graduate Analyst with offices at Pune and Bangalore .The CTC offered was 19.6 lpa 

Aptitude Round :

There were 3 Coding Questions :

2 Medium level of difficulty 

1 Hard level of difficulty

Time provided was 1.5 hrs

Interview Round 1 :

I did see his LinkedIn profile before Interview and got to know he had knowledge and experience of databases so I had cleared that he would take it deep into database.

He started it off with the first question of OS (maybe it was the same question which love babbar has in his OS notes).

Then he asked few more questions on OS (easy to medium level),

I think the OS playlist of Gate Smasher or Love babbar is enough (atleast for this interview)

then he asked about DBMS (ACID , transaction, 2nf

then asked few queries (find highest salary among the table with 3 different methods and nth highest salary, also asked how to join given two tables with some conditions) he also gave me some code snippets and asked me about their output 

Asked about OOPs and their importance 

then he moved towards DSA. 

Started with why do we need DSA?

Then adv of Linked list over Array , then many more questions followed up 

He asked how would you reverse a string (approach only )

Asked about searching methods and which is more efficient

Then there was discussion about projects

Interview Round 2 :

In the previous interview I was pretty good at answering questions of os dbms and project but I did fumble at dsa and also didn't answer a few questions thats where they thought that they need to test my dsa 

The Interviewer at the start itself said see I'm gonna ask you 15-20 questions and I have list of all these questions, then he read out all those questions, 

I had answers for nearly 60% of those and not for remaining ones 

So It started and questions were easy to medium level 

I was pretty nervous , was fumbling at nearly all questions so I asked for 2 mins of time so I calmed down myself 

He was giving me code snippets of data structures and asking me their outputs , in the whole interview he asked about 12-15 code snippets

Then he asked a few difficult questions (I'm unable to remember those)

Then he asked with programming how can u find a file in the computer

This interview was a bit of roller coaster one coz few of questions I was very good and not in a few, 

then he asked me a question to give approach using hash maps and I was unable to answer it then I asked him to give me some time to think then I gave him a approach using linked list and I kind of won him with that answer 

Then there were few more questions 

he asked me to code for few linked list questions 

I don't really remember if he asked about project 

This was a pretty difficult interview 

Interview Round 3 (Professional Fit Round ) :

This Round was non technical 

They asked about my family background , my hobbies and achievements 

Then asked about my weakness (I said currently I dont have any , I have worked upon my weaknesses ).  Then he asked me about finance (as I had mentioned it in the interview)

Then he went on to ask questions about hobbies and strengths 

Then he asked about my projects then asked about difficulties which I faced in my project and how did I tackle them

He gave me scenarios and asked how would I behave 

He was a pretty chill guy!

You can easily clear this round with good communication and confidence

Interview Round 4 (HR Round) :

General HR questions 

Why deutsche bank ? (prepare this answer prior to interview)

asked about my family background

Tips :

See guys you are students you aren't expected to know too much , its fine if you dont know many concepts , all they want is a confident grad willing to learn newer tech 

Don't be underconfident or overconfident 

the above questions are not all which they asked me, I don't remember all (so don't just prepare only these questions for interview )

Do prepare for HR interview 

Do prepare for standard project questions beforehand

I prepared for interviews like I thought that I have to win these interviewer so I did read a book ‘How to win friends and influence people’ before interview and did apply its concepts on interviewer.

This technique came pretty handy in profit round

Always Smile in a interview (smile in the sense that doesn't feel over)

Smile if you answer a question , smile even if you don't answer

Make sure you take control of little things so eventually you turn out result in your favour.

ALL THE BEST !!!!

Deutsche Bank Interview Experience(20/7/2023)

The whole process consists of 5 rounds:

1. Coding Round
2. Technical Interview 1
3. Technical Interview 2
4. Professional Fitness Round
5. HR Round

Coding Round:

Coding round was held on Hackerearth. Make sure you have a system compatible with hackerearth, many students face problems related to browser crashing, camera access etc.

Questions asked were of easy-medium level, some of the standard leetcode questions.
First question was based on Two pointers, Second one was based on Binary search and Third one was based on prefix sum.

Tip: Make sure you attempt all the questions by brute force at least. Some of the    students were shortlisted even after partially solving one or two questions.

Technical Interview 1:

The interview started with my basic introduction, then 

• Pillars of OOP
• Give real life examples of pillars of OOP in this room itself. (We were sitting in the library, hence real life examples of pillars of OOP related to the library.)
• Coding Question: Given a string, check if all the characters in the string are grouped or not. If grouped, string is valid, else invalid.

(For example, aaabbbccccc is valid ,    aabbaacc is invalid)

(He asked me two do the coding on online compiler, and then checked if code 

Works for all the cases)

• Difference between BFS and DFS. Examples like when to use BFS and when to use DFS.
• Difference between linear and circular linked list.
• Some basic questions related to the project, like why this problem statement, tech stack etc.
• Then he asked a sql query based upon joins and aggregate functions.
  
   

Out of 44 shortlisted for interviews, 32 were shortlisted for next round.

Technical Interview 2:

• Started with basic introduction
• Then he started asking some puzzles:

1. 6, 9, 18, 27, ??, 2241 : Find the missing term
2. There is a tunnel of max height 13 feet and a truck standing in front of a tunnel of height 13.1 feet. What will you do to pass the truck?
3. There are some rabbits and chickens in a cage. Total number of heads is 72 and the total number of legs is 200. Calculate individual count.

• If given the chance, which technology or which domain would you like to work in? Why? Have you done anything related to that particular domain till now?
• As I had project using MERN stack, he asked some questions related to Javascript:
  • Features of ES6
  • Significance of Fat arrow function
  • Closures in Javascript
  • Spread operator in Javascript

• Coding question: Given a string consisting of lowercase alphabets, return all the palindromic substrings of a given string. He asked for a dry run on paper as well.

Out of 32, 19 were selected for next round.

Profit Round(Professional Fitness Round):

• He started with hobbies mentioned in the resume, and I was having one as wildlife photography. We had a brief discussion on wildlife photography.
• He asked if I had decided on my final year project. Some questions related to that problem statement.
• Any plans for further education?

Out of 19, 16 were selected for final (HR) round.

HR Round:

• Tell me your 3 qualities/strengths. Justify them with your experiences.
• As I mentioned in the resume that I organized the WCE Hackathon’23, she asked some questions regarding it:
  • What was the format?
  • What was that unique thing that you put on the table, which others probably could not?
  • What challenges did you face?

• Some scenario based questions:
  • What will you do when one of your team member is not responding at all?
  • What if all of the members are good, but there is lack of synchronization, like each and everyone has some different thoughts?
  • If there is something going wrong, then would you dare to stand and speak regarding it? Consider the fact that it might affect your growth and position.

Final verdict: Selected

Tips:

• Never ever miss a chance to stand and speak. Show your interest by asking questions during PPT and even when the interviewer asks if you have any questions for me? I asked the question: “How can I make the most of my final year of B.Tech? ”
• Develop good communication skills. It is the key when HR rounds are concerned. It helps a lot even in technical rounds as well.
• Focus on the basics.

All the best everyone!!

Deutsche Bank came to our campus on 16th July for Online Coding round followed by 4 Interview Rounds on 20th July.

1) Aptitude/Coding Round: 

It was a coding contest consisting of 3 coding questions. This round was conducted on hackerearth platform, so make sure you're comfortable with it.

• The difficulty level was easy to medium leetcode questions.
• The questions were based on Two Pointers, Binary Search and Prefix sum.
• Try to solve all the questions atleast by brute-force. 

45 students were shortlisted for further interview process.

2) Technical 1:  (45 min)

The interview started with the introduction. Then he asked me to introduce without mentioning technical stuff and academic background. Again he asked to give introduction for atleast 2 min.

I managed to hold introduction for 1.5 min.

After that he asked some questions about linux and told me to rate myself in linux, I said 7/10.

He asked a couple of questions I could answer some of them, then he asked again are you sure on your rating for linux, I said yes.

He asked favourite subject, I said DSA. He told to write any program using any DSA, I wrote a string search program using Trie and explained everything to him, he was quite impressed at that time. Then he asked some real-life applications and we had some discussions around this.

He also asked the basics of Memory hierarchy and some comparison. 

Then he moved to OS and asked some OS related questions.

32 students were selected for further interview process.

3) Technical 2:   (45 min)

The interview started with basic introduction. 

He started with asking questions about my projects. He asked about the challenges and how I overcame those challenges.

Then he saw MYSQL in my one of the project and started asking the DBMS related questions.

He asked me to design a database for a scenario.

-Create table on given conditions/constraints(constraints were wrong)

-Then he asked me to correct the constraints(by dropping them)

-Asked some SQL queries on joins, aggregate functions, group by, etc.(make sure you practice SQL beforehand)

Then He moved to DSA,

--Write a program to Convert Roman String to Decimal(IX → 9)

--Write a program to reverse a Linked List

Then he asked about OOPS,

--Pillars of OOPs,

--Real life examples of OOPS around us(in the library, as interview was conducted in Library)

19 students were selected for further interview process.

4) Professional Fitment Round:  (25 min)

The Round started with basic Introduction.

Then he asked me about my internship at Siemens.

• - Key takeaways from internship
• - What work I did
• - Asked about Gradle, TOML and Gitlab CI as I mentioned in my resume.

Then he asked some Situational Questions, what will you do if…

16 students were selected for HR round.

5) HR round:   (20 min)

Started with introduction, She asked me 

How was your day? What mistake you did? 

Why do you want to join DB?

Describe yourself in 3 words (cover the answer with proper examples).

What will you do if one of your colleague isn't working?

What will you do if you've arguments with making a decisions on a project?

Finally 15 students including me were selected for the Deutsche Bank Grad Offer.

TIPS:

1. Be confident and  have a smile on your face, even if you failed to give the answer.

2.  Try to communicate with the interviewer, ask doubts, they may give you wrong information and expect you to ask.

3. Discuss your approach while solving problem and ask for hints if you need.

4. Be ready with some examples supporting your answer.

5. Be ready for the common questions that can be asked on your projects.

ALL THE BEST